// sql语句
var sqlMap = {
    // 用户添加
    user: {
        add: 'insert into user(id, phone, password) values (?, ?, ?)',
        select_name: 'SELECT * from user where phone = ?',//查询 用户表
        // select_password: 'SELECT * from user where password = ?'//查询 password
        select_theThink:'SELECT * from thethink',//查询诗歌
        select_theWant:'SELECT * from thewant',//查询诗歌
        select_theLook:'SELECT * from thelook',//查询诗歌
        theThink_add:'insert into thethink (poetryName, author, first, second, third, fourth, img, parsing) values (?,?,?,?,?,?,?,?)',//添加诗歌
        theLook_add:'insert into thelook (poetryName, author, first, second, third, fourth, img, parsing) values (?,?,?,?,?,?,?,?)',//添加诗歌
        theWant_add:'insert into thewant (poetryName, author, first, second, third, fourth, img, parsing) values (?,?,?,?,?,?,?,?)',//添加诗歌
        select_theLife:'SELECT * from thelife',//查询图片
        select_more:'SELECT * from more',//查询更多界面的数据
        select_vlogo:'SELECT * from vlogo',//查询vlogo界面的数据
    }
}
module.exports = sqlMap;